| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `ShikomoriWord`.`id`, `ShikomoriWord`.`parent_id`, `ShikomoriWord`.`num_class`, `ShikomoriWord`.`word`, `ShikomoriWord`.`various_forms`, `ShikomoriWord`.`from_verb_id`, `ShikomoriWord`.`origin`, `ShikomoriWord`.`origin_history`, `ShikomoriWord`.`category`, `ShikomoriWord`.`category2`, `ShikomoriWord`.`category3`, `ShikomoriWord`.`is_shingazidja`, `ShikomoriWord`.`is_shindzuani`, `ShikomoriWord`.`is_shimaore`, `ShikomoriWord`.`is_shimwali`, `ShikomoriWord`.`is_standard`, `ShikomoriWord`.`is_neology`, `ShikomoriWord`.`is_transparent`, `ShikomoriWord`.`has_definition`, `ShikomoriWord`.`has_infinitive`, `ShikomoriWord`.`has_plural`, `ShikomoriWord`.`in_front`, `ShikomoriWord`.`generated_word`, `ShikomoriWord`.`active`, `ShikomoriWord`.`closed`, `ShikomoriWord`.`in_error`, `ShikomoriWord`.`date_created`, `ShikomoriWord`.`date_updated`, `ShikomoriWord`.`date_day_word`, `ShikomoriWord`.`used_in_word_of_day`, `ShikomoriWord`.`is_collective`, `ShikomoriWord`.`creator_id`, `ShikomoriWord`.`editor_id`, `ShikomoriWord`.`reserved_by_editor`, `ShikomoriWord`.`finished_by_editor`, `ShikomoriVerb`.`id`, `ShikomoriVerb`.`word`, `ShikomoriVerb`.`radical`, `ShikomoriVerb`.`root`, `ShikomoriVerb`.`category`, `ShikomoriVerb`.`category2`, `ShikomoriVerb`.`verb_ending`, `ShikomoriVerb`.`form`, `ShikomoriVerb`.`relator_form1`, `ShikomoriVerb`.`relator_form2`, `ShikomoriVerb`.`imperative_form`, `ShikomoriVerb`.`accompli_form`, `ShikomoriVerb`.`initial_form_id`, `ShikomoriVerb`.`shikomori_id`, `ShikomoriVerb`.`active`, `ShikomoriVerb`.`closed`, `ShikomoriVerb`.`date_created`, `ShikomoriVerb`.`date_updated`, `ShikomoriVerb`.`is_collective`, `ShikomoriVerb`.`creator_id`, `ShikomoriVerb`.`editor_id` FROM `noniseshorelc`.`shikomori_words` AS `ShikomoriWord` LEFT JOIN `noniseshorelc`.`shikomori_verbs` AS `ShikomoriVerb` ON (`ShikomoriVerb`.`shikomori_id` = `ShikomoriWord`.`id`) WHERE `ShikomoriWord`.`word` LIKE 'ɗisa (u-)%' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ShikomoriDefinition`.`id`, `ShikomoriDefinition`.`context`, `ShikomoriDefinition`.`explanation`, `ShikomoriDefinition`.`example_in_shingazidja`, `ShikomoriDefinition`.`example_in_shindzuani`, `ShikomoriDefinition`.`example_in_shimwali`, `ShikomoriDefinition`.`example_in_shimaore`, `ShikomoriDefinition`.`example_in_french`, `ShikomoriDefinition`.`example_in_english`, `ShikomoriDefinition`.`theme`, `ShikomoriDefinition`.`position`, `ShikomoriDefinition`.`shikomori_id`, `ShikomoriDefinition`.`active`, `ShikomoriDefinition`.`date_created`, `ShikomoriDefinition`.`date_updated`, `ShikomoriDefinition`.`is_collective`, `ShikomoriDefinition`.`creator_id`, `ShikomoriDefinition`.`editor_id` FROM `noniseshorelc`.`shikomori_definitions` AS `ShikomoriDefinition` WHERE `ShikomoriDefinition`.`shikomori_id` = (1932) | 0 | 0 | 0 | |
| SELECT `FrenchWord`.`id`, `FrenchWord`.`word`, `FrenchWord`.`kind`, `FrenchWord`.`category`, `FrenchWord`.`employ`, `FrenchWord`.`category2`, `FrenchWord`.`category3`, `FrenchWord`.`has_definition`, `FrenchWord`.`active`, `FrenchWord`.`closed`, `FrenchWord`.`date_created`, `FrenchWord`.`date_updated`, `FrenchWord`.`is_collective`, `FrenchWord`.`creator_id`, `FrenchWord`.`editor_id`, `ShikomoriFrWord`.`id`, `ShikomoriFrWord`.`shikomori_id`, `ShikomoriFrWord`.`french_id`, `ShikomoriFrWord`.`language_registers`, `ShikomoriFrWord`.`for_dialects`, `ShikomoriFrWord`.`position` FROM `noniseshorelc`.`french_words` AS `FrenchWord` JOIN `noniseshorelc`.`shikomori_fr_words` AS `ShikomoriFrWord` ON (`ShikomoriFrWord`.`shikomori_id` = 1932 AND `ShikomoriFrWord`.`french_id` = `FrenchWord`.`id`) ORDER BY `ShikomoriFrWord`.`position` ASC | 2 | 2 | 0 | |
| SELECT `EnglishWord`.`id`, `EnglishWord`.`word`, `EnglishWord`.`kind`, `EnglishWord`.`category`, `EnglishWord`.`employ`, `EnglishWord`.`category2`, `EnglishWord`.`category3`, `EnglishWord`.`has_definition`, `EnglishWord`.`active`, `EnglishWord`.`closed`, `EnglishWord`.`date_created`, `EnglishWord`.`date_updated`, `EnglishWord`.`is_collective`, `EnglishWord`.`creator_id`, `EnglishWord`.`editor_id`, `ShikomoriEnWord`.`id`, `ShikomoriEnWord`.`shikomori_id`, `ShikomoriEnWord`.`english_id`, `ShikomoriEnWord`.`language_registers`, `ShikomoriEnWord`.`for_dialects`, `ShikomoriEnWord`.`position` FROM `noniseshorelc`.`english_words` AS `EnglishWord` JOIN `noniseshorelc`.`shikomori_en_words` AS `ShikomoriEnWord` ON (`ShikomoriEnWord`.`shikomori_id` = 1932 AND `ShikomoriEnWord`.`english_id` = `EnglishWord`.`id`) | 1 | 1 | 0 | |
| SELECT `ArabicWord`.`id`, `ArabicWord`.`word`, `ArabicWord`.`kind`, `ArabicWord`.`category`, `ArabicWord`.`employ`, `ArabicWord`.`category2`, `ArabicWord`.`category3`, `ArabicWord`.`has_definition`, `ArabicWord`.`active`, `ArabicWord`.`closed`, `ArabicWord`.`date_created`, `ArabicWord`.`date_updated`, `ArabicWord`.`is_collective`, `ArabicWord`.`creator_id`, `ArabicWord`.`editor_id`, `ShikomoriArWord`.`id`, `ShikomoriArWord`.`shikomori_id`, `ShikomoriArWord`.`arabic_id`, `ShikomoriArWord`.`language_registers`, `ShikomoriArWord`.`for_dialects`, `ShikomoriArWord`.`position` FROM `noniseshorelc`.`arabic_words` AS `ArabicWord` JOIN `noniseshorelc`.`shikomori_ar_words` AS `ShikomoriArWord` ON (`ShikomoriArWord`.`shikomori_id` = 1932 AND `ShikomoriArWord`.`arabic_id` = `ArabicWord`.`id`) | 0 | 0 | 0 | |
| SELECT `ShikomoriPlural`.`id`, `ShikomoriPlural`.`num_class`, `ShikomoriPlural`.`word`, `ShikomoriPlural`.`active`, `ShikomoriPlural`.`closed`, `ShikomoriPlural`.`date_created`, `ShikomoriPlural`.`date_updated`, `ShikomoriPlural`.`is_collective`, `ShikomoriPlural`.`creator_id`, `ShikomoriPlural`.`editor_id`, `ShikomoriPlWord`.`id`, `ShikomoriPlWord`.`plural_id`, `ShikomoriPlWord`.`shikomori_id`, `ShikomoriPlWord`.`language_registers`, `ShikomoriPlWord`.`for_dialects`, `ShikomoriPlWord`.`position` FROM `noniseshorelc`.`shikomori_plurals` AS `ShikomoriPlural` JOIN `noniseshorelc`.`shikomori_pl_words` AS `ShikomoriPlWord` ON (`ShikomoriPlWord`.`shikomori_id` = 1932 AND `ShikomoriPlWord`.`plural_id` = `ShikomoriPlural`.`id`) | 0 | 0 | 1 | maybe slow |
| SELECT count(*) AS total FROM `comments` AS Comment WHERE date_created > now() + interval - 2 month AND `shikomori_id` = 1932 | 1 | 1 | 0 | |
| SELECT `ShikomoriVerb`.`id`, `ShikomoriVerb`.`word`, `ShikomoriVerb`.`radical`, `ShikomoriVerb`.`root`, `ShikomoriVerb`.`category`, `ShikomoriVerb`.`category2`, `ShikomoriVerb`.`verb_ending`, `ShikomoriVerb`.`form`, `ShikomoriVerb`.`relator_form1`, `ShikomoriVerb`.`relator_form2`, `ShikomoriVerb`.`imperative_form`, `ShikomoriVerb`.`accompli_form`, `ShikomoriVerb`.`initial_form_id`, `ShikomoriVerb`.`shikomori_id`, `ShikomoriVerb`.`active`, `ShikomoriVerb`.`closed`, `ShikomoriVerb`.`date_created`, `ShikomoriVerb`.`date_updated`, `ShikomoriVerb`.`is_collective`, `ShikomoriVerb`.`creator_id`, `ShikomoriVerb`.`editor_id` FROM `noniseshorelc`.`shikomori_verbs` AS `ShikomoriVerb` WHERE `ShikomoriVerb`.`id` = 145 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShikomoriWord`.`id`, `ShikomoriWord`.`parent_id`, `ShikomoriWord`.`num_class`, `ShikomoriWord`.`word`, `ShikomoriWord`.`various_forms`, `ShikomoriWord`.`from_verb_id`, `ShikomoriWord`.`origin`, `ShikomoriWord`.`origin_history`, `ShikomoriWord`.`category`, `ShikomoriWord`.`category2`, `ShikomoriWord`.`category3`, `ShikomoriWord`.`is_shingazidja`, `ShikomoriWord`.`is_shindzuani`, `ShikomoriWord`.`is_shimaore`, `ShikomoriWord`.`is_shimwali`, `ShikomoriWord`.`is_standard`, `ShikomoriWord`.`is_neology`, `ShikomoriWord`.`is_transparent`, `ShikomoriWord`.`has_definition`, `ShikomoriWord`.`has_infinitive`, `ShikomoriWord`.`has_plural`, `ShikomoriWord`.`in_front`, `ShikomoriWord`.`generated_word`, `ShikomoriWord`.`active`, `ShikomoriWord`.`closed`, `ShikomoriWord`.`in_error`, `ShikomoriWord`.`date_created`, `ShikomoriWord`.`date_updated`, `ShikomoriWord`.`date_day_word`, `ShikomoriWord`.`used_in_word_of_day`, `ShikomoriWord`.`is_collective`, `ShikomoriWord`.`creator_id`, `ShikomoriWord`.`editor_id`, `ShikomoriWord`.`reserved_by_editor`, `ShikomoriWord`.`finished_by_editor`, `ShikomoriVerb`.`id`, `ShikomoriVerb`.`word`, `ShikomoriVerb`.`radical`, `ShikomoriVerb`.`root`, `ShikomoriVerb`.`category`, `ShikomoriVerb`.`category2`, `ShikomoriVerb`.`verb_ending`, `ShikomoriVerb`.`form`, `ShikomoriVerb`.`relator_form1`, `ShikomoriVerb`.`relator_form2`, `ShikomoriVerb`.`imperative_form`, `ShikomoriVerb`.`accompli_form`, `ShikomoriVerb`.`initial_form_id`, `ShikomoriVerb`.`shikomori_id`, `ShikomoriVerb`.`active`, `ShikomoriVerb`.`closed`, `ShikomoriVerb`.`date_created`, `ShikomoriVerb`.`date_updated`, `ShikomoriVerb`.`is_collective`, `ShikomoriVerb`.`creator_id`, `ShikomoriVerb`.`editor_id` FROM `noniseshorelc`.`shikomori_words` AS `ShikomoriWord` LEFT JOIN `noniseshorelc`.`shikomori_verbs` AS `ShikomoriVerb` ON (`ShikomoriVerb`.`shikomori_id` = `ShikomoriWord`.`id`) WHERE `ShikomoriWord`.`id` = 1923 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ShikomoriDefinition`.`id`, `ShikomoriDefinition`.`context`, `ShikomoriDefinition`.`explanation`, `ShikomoriDefinition`.`example_in_shingazidja`, `ShikomoriDefinition`.`example_in_shindzuani`, `ShikomoriDefinition`.`example_in_shimwali`, `ShikomoriDefinition`.`example_in_shimaore`, `ShikomoriDefinition`.`example_in_french`, `ShikomoriDefinition`.`example_in_english`, `ShikomoriDefinition`.`theme`, `ShikomoriDefinition`.`position`, `ShikomoriDefinition`.`shikomori_id`, `ShikomoriDefinition`.`active`, `ShikomoriDefinition`.`date_created`, `ShikomoriDefinition`.`date_updated`, `ShikomoriDefinition`.`is_collective`, `ShikomoriDefinition`.`creator_id`, `ShikomoriDefinition`.`editor_id` FROM `noniseshorelc`.`shikomori_definitions` AS `ShikomoriDefinition` WHERE `ShikomoriDefinition`.`shikomori_id` = (1923) | 0 | 0 | 0 | |
| SELECT `FrenchWord`.`id`, `FrenchWord`.`word`, `FrenchWord`.`kind`, `FrenchWord`.`category`, `FrenchWord`.`employ`, `FrenchWord`.`category2`, `FrenchWord`.`category3`, `FrenchWord`.`has_definition`, `FrenchWord`.`active`, `FrenchWord`.`closed`, `FrenchWord`.`date_created`, `FrenchWord`.`date_updated`, `FrenchWord`.`is_collective`, `FrenchWord`.`creator_id`, `FrenchWord`.`editor_id`, `ShikomoriFrWord`.`id`, `ShikomoriFrWord`.`shikomori_id`, `ShikomoriFrWord`.`french_id`, `ShikomoriFrWord`.`language_registers`, `ShikomoriFrWord`.`for_dialects`, `ShikomoriFrWord`.`position` FROM `noniseshorelc`.`french_words` AS `FrenchWord` JOIN `noniseshorelc`.`shikomori_fr_words` AS `ShikomoriFrWord` ON (`ShikomoriFrWord`.`shikomori_id` = 1923 AND `ShikomoriFrWord`.`french_id` = `FrenchWord`.`id`) ORDER BY `ShikomoriFrWord`.`position` ASC | 1 | 1 | 1 | |
| SELECT `EnglishWord`.`id`, `EnglishWord`.`word`, `EnglishWord`.`kind`, `EnglishWord`.`category`, `EnglishWord`.`employ`, `EnglishWord`.`category2`, `EnglishWord`.`category3`, `EnglishWord`.`has_definition`, `EnglishWord`.`active`, `EnglishWord`.`closed`, `EnglishWord`.`date_created`, `EnglishWord`.`date_updated`, `EnglishWord`.`is_collective`, `EnglishWord`.`creator_id`, `EnglishWord`.`editor_id`, `ShikomoriEnWord`.`id`, `ShikomoriEnWord`.`shikomori_id`, `ShikomoriEnWord`.`english_id`, `ShikomoriEnWord`.`language_registers`, `ShikomoriEnWord`.`for_dialects`, `ShikomoriEnWord`.`position` FROM `noniseshorelc`.`english_words` AS `EnglishWord` JOIN `noniseshorelc`.`shikomori_en_words` AS `ShikomoriEnWord` ON (`ShikomoriEnWord`.`shikomori_id` = 1923 AND `ShikomoriEnWord`.`english_id` = `EnglishWord`.`id`) | 1 | 1 | 1 | |
| SELECT `ArabicWord`.`id`, `ArabicWord`.`word`, `ArabicWord`.`kind`, `ArabicWord`.`category`, `ArabicWord`.`employ`, `ArabicWord`.`category2`, `ArabicWord`.`category3`, `ArabicWord`.`has_definition`, `ArabicWord`.`active`, `ArabicWord`.`closed`, `ArabicWord`.`date_created`, `ArabicWord`.`date_updated`, `ArabicWord`.`is_collective`, `ArabicWord`.`creator_id`, `ArabicWord`.`editor_id`, `ShikomoriArWord`.`id`, `ShikomoriArWord`.`shikomori_id`, `ShikomoriArWord`.`arabic_id`, `ShikomoriArWord`.`language_registers`, `ShikomoriArWord`.`for_dialects`, `ShikomoriArWord`.`position` FROM `noniseshorelc`.`arabic_words` AS `ArabicWord` JOIN `noniseshorelc`.`shikomori_ar_words` AS `ShikomoriArWord` ON (`ShikomoriArWord`.`shikomori_id` = 1923 AND `ShikomoriArWord`.`arabic_id` = `ArabicWord`.`id`) | 0 | 0 | 0 | |
| SELECT `ShikomoriPlural`.`id`, `ShikomoriPlural`.`num_class`, `ShikomoriPlural`.`word`, `ShikomoriPlural`.`active`, `ShikomoriPlural`.`closed`, `ShikomoriPlural`.`date_created`, `ShikomoriPlural`.`date_updated`, `ShikomoriPlural`.`is_collective`, `ShikomoriPlural`.`creator_id`, `ShikomoriPlural`.`editor_id`, `ShikomoriPlWord`.`id`, `ShikomoriPlWord`.`plural_id`, `ShikomoriPlWord`.`shikomori_id`, `ShikomoriPlWord`.`language_registers`, `ShikomoriPlWord`.`for_dialects`, `ShikomoriPlWord`.`position` FROM `noniseshorelc`.`shikomori_plurals` AS `ShikomoriPlural` JOIN `noniseshorelc`.`shikomori_pl_words` AS `ShikomoriPlWord` ON (`ShikomoriPlWord`.`shikomori_id` = 1923 AND `ShikomoriPlWord`.`plural_id` = `ShikomoriPlural`.`id`) | 0 | 0 | 2 | maybe slow |
| SELECT `ShikomoriVerb`.`word`, `ShikomoriVerb`.`radical` FROM `noniseshorelc`.`shikomori_verbs` AS `ShikomoriVerb` WHERE ((`ShikomoriVerb`.`active` = '1') AND (`ShikomoriVerb`.`radical` NOT LIKE '')) ORDER BY `ShikomoriVerb`.`word` ASC | 1937 | 1937 | 6 | |
| SELECT `FrenchWord`.`id`, `FrenchWord`.`word` FROM `noniseshorelc`.`french_words` AS `FrenchWord` WHERE ((`FrenchWord`.`active` = '1') AND (`FrenchWord`.`word` NOT LIKE '') AND (`FrenchWord`.`category` LIKE 'v.%')) ORDER BY `FrenchWord`.`word` ASC | 1927 | 1927 | 9 | |
| SELECT ShikomoriSynonym.id, ShikomoriSynonym.word, French.id, French.word, is_shingazidja, is_shindzuani, is_shimaore, is_shimwali, is_standard, is_neology FROM `shikomori_words` AS ShikomoriSynonym, french_words AS French, shikomori_fr_words AS kmfr WHERE ShikomoriSynonym.id = kmfr.shikomori_id AND French.id = kmfr.french_id AND French.word LIKE 'bouger' ORDER BY CHAR_LENGTH(French.word), CHAR_LENGTH(ShikomoriSynonym.word), ShikomoriSynonym.word | 3 | 3 | 1 | maybe slow |
| SELECT ShikomoriSynonym.id, ShikomoriSynonym.word, French.id, French.word, is_shingazidja, is_shindzuani, is_shimaore, is_shimwali, is_standard, is_neology FROM `shikomori_words` AS ShikomoriSynonym, french_words AS French, shikomori_fr_words AS kmfr WHERE ShikomoriSynonym.id = kmfr.shikomori_id AND French.id = kmfr.french_id AND French.word LIKE 'secouer' ORDER BY CHAR_LENGTH(French.word), CHAR_LENGTH(ShikomoriSynonym.word), ShikomoriSynonym.word | 4 | 4 | 1 | maybe slow |